<?php defined('BASEPATH') or exit('No direct script access allowed');

class Module_Database_definition extends Module {

	public $version = 0.9;

	public function info()
	{
		return array(
			'name' => array(
				'es' => 'Database Definition',
				'en' => 'Database Definition'
		),
			'description' => array(
				'es' => 'Database Definition',
				'en' => 'Database Definition'
		),
			'frontend' => TRUE,
			'backend' => TRUE,
			'menu'		=> 'content'
		);
	}

	public function install()
	{
		/*
		$this->dbforge->drop_table('escort_users');
		$this->dbforge->drop_table('escort_escorts');
		$this->dbforge->drop_table('escort_permissions');
		$this->dbforge->drop_table('escort_categories');
		$this->dbforge->drop_table('escort_languages');
		$this->dbforge->drop_table('escort_country_settings');
		$this->dbforge->drop_table('escort_payment_gateways');
		$this->dbforge->drop_table('escort_site_settings');
		$this->dbforge->drop_table('escort_sexual_orientations');
		$this->dbforge->drop_table('escort_province_settings');
		$this->dbforge->drop_table('escort_city_settings');
		$this->dbforge->drop_table('escort_ads_zones');
		$this->dbforge->drop_table('escort_ads_banners');
		$this->dbforge->drop_table('escort_subcription_options');
		$this->dbforge->drop_table('escort_hair_color_options');
		$this->dbforge->drop_table('escort_media_type_settings');
		$this->dbforge->drop_table('escort_service_options');
		$this->dbforge->drop_table('escort_package_settings');
		$this->dbforge->drop_table('escort_escort_descriptions');
		$this->dbforge->drop_table('escort_news');
		$this->dbforge->drop_table('escort_working_places');
		$this->dbforge->drop_table('escort_escort_schedule');
		$this->dbforge->drop_table('escort_week_days');
		$this->dbforge->drop_table('escort_payment_types');
		$this->dbforge->drop_table('escort_travel_options');
		$this->dbforge->drop_table('escort_serves_to_options');
		$this->dbforge->drop_table('escort_payment_methods');
		$this->dbforge->drop_table('escort_pricing_time_options');
		$this->dbforge->drop_table('escort_pricing_time');
		$this->dbforge->drop_table('escort_extras_options');
		$this->dbforge->drop_table('escort_sex_options');
		$this->dbforge->drop_table('escort_hair_size_options');
		$this->dbforge->drop_table('escort_hair_style_options');
		$this->dbforge->drop_table('escort_eye_options');
		$this->dbforge->drop_table('escort_transport_options');
		$this->dbforge->drop_table('escort_working_dates');
*/
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_users')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			 `username` VARCHAR(45) NULL ,
			  `password` VARCHAR(45) NULL ,		
			  `permission_id` INT NULL ,		
			  `name` VARCHAR(45) NULL ,		
			  `email` VARCHAR(45) NULL ,		
			  `address` VARCHAR(45) NULL ,		
			  `phone` VARCHAR(45) NULL ,		
			  `created_time` INT NULL ,		
			  `comission` FLOAT NULL ,		
			  `country_id` INT NULL ,		
			  `site_id` INT NULL ,
			  PRIMARY KEY (`id`) ,
			   UNIQUE INDEX `user_name_UNIQUE` (`username` ASC)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_permissions')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			  `name` VARCHAR(45) NULL ,
			  `slug` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_categories')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			  `language_id` INT NULL ,
  			  `code` INT NULL ,
  			  `category` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_languages')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			  `language` VARCHAR(45) NULL ,
			  `code` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_country_settings')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				`country` VARCHAR(45) NULL ,
  				`payment_gateway_ids` VARCHAR(45) NULL ,
  				`tax` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_payment_gateways')." (
			    `id` INT NOT NULL AUTO_INCREMENT ,
				`gateway` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_site_settings')." (
				`site_id` INT NOT NULL ,
			  `country_ids` VARCHAR(45) NULL ,			
			  `province_ids` VARCHAR(45) NULL ,			
			  `language_ids` VARCHAR(45) NULL ,			
			  `escort_category_ids` VARCHAR(45) NULL ,			
			  `sexual_orientation_ids` VARCHAR(45) NULL ,			
			  `main_site_language_id` INT NULL ,
			  PRIMARY KEY (`site_id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_sexual_orientations')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				`language_id` INT NULL ,
 				 `code` INT NULL ,
  				`orientation` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_province_settings')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				`province` VARCHAR(45) NULL ,
 				 `country_id` INT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_city_settings')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				`city` VARCHAR(45) NULL ,
			  `province_id` INT NULL ,		
			  `country_id` INT NULL ,			
			  `discount` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_ads_zones')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
				
				  `zone` VARCHAR(45) NULL ,
				
				  `code` VARCHAR(45) NULL ,
				
				  `width` INT NULL ,
				
				  `height` INT NULL ,
				
				  `site_ids` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_ads_banners')." (

			  `id` INT NOT NULL AUTO_INCREMENT ,

			  `user_added` VARCHAR(45) NULL ,
			
			  `permission_slug` VARCHAR(45) NULL ,
			
			  `site_ids` VARCHAR(45) NULL ,
			
			  `ads_zone_id` INT NULL ,
			
			  `banner_type` VARCHAR(45) NULL ,
			
			  `define_text` VARCHAR(255) NULL ,
			
			  `title` VARCHAR(255) NULL ,
			
			  `follow` INT NULL ,
			
			  `image` VARCHAR(255) NULL ,
			
			  `alt_image` VARCHAR(255) NULL ,
			
			  `link` VARCHAR(100) NULL ,
			
			  `width` INT NULL ,
			
			  `height` INT NULL ,
			
			  `script` TEXT NULL ,
			
			  `display_after_login` INT NULL ,
			
			  `updated_time` INT NULL ,
			
			  `active` INT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");

		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_subcription_options')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `option` VARCHAR(45) NULL ,
				  `price` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_hair_color_options')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				  `language_id` INT NULL ,
			  `code` INT NULL ,
			  `hair_color` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_media_type_settings')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `media_type` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_service_options')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				 `language_id` INT NULL ,
				  `code` INT NULL ,
				  `service` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_package_options')." (
				`id` INT NOT NULL AUTO_INCREMENT ,
  				 `language_id` INT NULL ,
				  `code` INT NULL ,
				  `package` VARCHAR(45) NULL ,
				  `price` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_escort_descriptions')." (
  				  `user_id` INT NOT NULL ,
				  `description` TEXT NULL ,
				  `language_id` INT NULL ,
			  PRIMARY KEY (`user_id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_news_categories')." (
  				  `id` INT NOT NULL AUTO_INCREMENT ,
  				  `category` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_news')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,

				  `title` VARCHAR(255) NULL ,
				
				  `news` TINYTEXT NULL ,
				
				  `category_id` INT NULL ,
				
				  `language_id` INT NULL ,
				
				  `site_ref` VARCHAR(45) NULL ,
				
				  `created_time` VARCHAR(45) NULL ,
				
				  `status` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_working_places')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				 `language_id` INT NULL ,
				  `code` INT NULL ,
				  `working_place` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_schedule')." (
  				 `user_id` INT NOT NULL ,
				  `week_day` INT NULL ,
				  `from` TIME NULL ,
				  `to` TIME NULL ,
			  PRIMARY KEY (`user_id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_week_days')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `week_day` VARCHAR(45) NULL ,
				  `order` INT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_payment_types')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				 `language_id` INT NULL ,
				  `code` INT NULL ,
				  `type` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_travel_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				 `language_id` INT NULL ,
				  `code` INT NULL ,
				  `option` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_serves_to_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `option` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_payment_methods')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `method` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_pricing_time_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `time` VARCHAR(45) NULL ,
				  `measure` VARCHAR(45) NULL ,
				  `order` INT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_pricing_time')." (
  				`user_id` INT NOT NULL ,
				  `pricing_time_id` INT NULL ,
				  `price` FLOAT NULL
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_extras_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				   `language_id` INT NULL ,
				  `code` INT NULL ,
				  `extras` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_sex_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				   `language_id` INT NULL ,
				  `code` INT NULL ,
				  `sex` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_hair_size_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				    `language_id` INT NULL ,
				  `code` INT NULL ,
				  `hair_style` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_hair_style_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				   `language_id` INT NULL ,
				  `code` INT NULL ,
				  `hair_color` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_eye_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				  `language_id` INT NULL ,
				  `code` INT NULL ,
				  `eye` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_transport_options')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				 `language_id` INT NULL ,
				  `code` INT NULL ,		
				  `transport` VARCHAR(45) NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_working_dates')." (
  				 `id` INT NOT NULL AUTO_INCREMENT ,
				   `user_id` INT NULL ,
				  `year` INT NULL ,
				  `months_n_dates` MEDIUMTEXT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_priority_options')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			  `priority` FLOAT NULL ,
			  `price` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
		$this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_listing_place_options')." (
			  `id` INT NOT NULL AUTO_INCREMENT ,
			
			  `country_id` INT NULL ,
			
			  `province_id` INT NULL ,
			
			  `city_id` INT NULL ,
			
			  `price` FLOAT NULL ,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
				
		return $this->db->query("
			CREATE  TABLE IF NOT EXISTS ".$this->db->dbprefix('escort_escorts')." (
			 `user_id` INT NOT NULL ,
			  `times_visited` INT NULL ,		
			  `times_phone_displayed` INT NULL ,		
			  `wallet` FLOAT NULL ,		
			  `sex` VARCHAR(45) NULL ,		
			  `public_sex` INT NULL ,		
			  `sexual_orientation_id` INT NULL ,		
			  `public_sexual_orientation` INT NULL ,		
			  `birth_date` INT NULL ,	
			  `public_birth_date` INT NULL ,		
			  `country_id` INT NULL ,		
			  `public_country` INT NULL ,		
			  `hair_color_id` INT NULL ,		
			  `hair_size_id` INT NULL ,			
			  `hair_style_id` INT NULL ,			
			  `public_hair` INT NULL ,			
			  `eye_id` INT NULL ,			
			  `public_eye` INT NULL ,			
			  `height` FLOAT NULL ,			
			  `public_height` INT NULL ,			
			  `weight` FLOAT NULL ,		
			  `public_weight` INT NULL ,			
			  `measure_1` FLOAT NULL ,			
			  `measure_2` FLOAT NULL ,			
			  `measure_3` FLOAT NULL ,			
			  `public_measures` INT NULL ,			
			  `public_schedule` INT NULL ,			
			  `working_place_ids` VARCHAR(45) NULL ,			
			  `public_working_places` INT NULL ,			
			  `travel_ids` VARCHAR(45) NULL ,			
			  `public_travel` INT NULL ,		
			  `serve_to_ids` VARCHAR(45) NULL ,			
			  `public_serve_to` INT NULL ,			
			  `service_ids` VARCHAR(45) NULL ,			
			  `public_services` INT NULL ,			
			  `payment_method_ids` VARCHAR(45) NULL ,			
			  `public_payment_method` INT NULL ,			
			  `transport_include_id` INT NULL ,			
			  `public_transport_include` INT NULL ,			
			  `public_phone` INT NULL ,
			  `public_email` INT NULL ,			
			  `public_address` INT NULL ,
			  `geolocation` VARCHAR(45) NULL ,			
			  `public_geolocation` INT NULL ,			
			  `public_map` INT NULL ,
			  `show_address_on_map` INT NULL ,
			  `receive_message` INT NULL ,
			  `promotion_code` VARCHAR(45) NULL ,
			  `commercial_lead` INT NULL ,
			  `package_ids` VARCHAR(45) NULL ,
			  `serves_to_ids` VARCHAR(45) NULL ,
			  `public_serves_to` INT NULL ,
			  `public_working_calendar` INT NULL ,
			  `public_pricing_time` INT NULL ,
			  `extras_ids` INT NULL ,
			  `public_extras` INT NULL ,
			   PRIMARY KEY (`user_id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8
		");
	}

	public function uninstall()
	{
		/*
		$this->dbforge->drop_table('escort_users');
		$this->dbforge->drop_table('escort_escorts');
		$this->dbforge->drop_table('escort_permissions');
		$this->dbforge->drop_table('escort_categories');
		$this->dbforge->drop_table('escort_languages');
		$this->dbforge->drop_table('escort_country_settings');
		$this->dbforge->drop_table('escort_payment_gateways');
		$this->dbforge->drop_table('escort_site_settings');
		$this->dbforge->drop_table('escort_sexual_orientations');
		$this->dbforge->drop_table('escort_province_settings');
		$this->dbforge->drop_table('escort_city_settings');
		$this->dbforge->drop_table('escort_ads_zones');
		$this->dbforge->drop_table('escort_ads_banners');
		$this->dbforge->drop_table('escort_subcription_options');
		$this->dbforge->drop_table('escort_hair_color_options');
		$this->dbforge->drop_table('escort_media_type_settings');
		$this->dbforge->drop_table('escort_service_options');
		$this->dbforge->drop_table('escort_package_options');
		$this->dbforge->drop_table('escort_escort_descriptions');
		$this->dbforge->drop_table('escort_news');
		$this->dbforge->drop_table('escort_working_places');
		$this->dbforge->drop_table('escort_escort_schedule');
		$this->dbforge->drop_table('escort_week_days');
		$this->dbforge->drop_table('escort_payment_types');
		$this->dbforge->drop_table('escort_travel_options');
		$this->dbforge->drop_table('escort_serves_to_options');
		$this->dbforge->drop_table('escort_payment_methods');
		$this->dbforge->drop_table('escort_pricing_time_options');
		$this->dbforge->drop_table('escort_pricing_time');
		$this->dbforge->drop_table('escort_extras_options');
		$this->dbforge->drop_table('escort_sex_options');
		$this->dbforge->drop_table('escort_hair_size_options');
		$this->dbforge->drop_table('escort_hair_style_options');
		$this->dbforge->drop_table('escort_eye_options');
		$this->dbforge->drop_table('escort_transport_options');
		$this->dbforge->drop_table('escort_working_dates');
		*/
		return TRUE;
	}

	public function upgrade($old_version)
	{
		// Your Upgrade Logic
		return TRUE;
	}

	public function help()
	{
		// Return a string containing help info
		// You could include a file and return it here.
		return "This module has no inline docs as it does not have a back-end.";
	}
}
/* End of file details.php */